package com.ruoyi.system.Fdongbei.mapper;

import com.ruoyi.system.Fdongbei.domain.TbSdI;
import org.apache.ibatis.annotations.Select;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author fufeng
 * @since 2024-12-09
 */
public interface TbSdIMapper  {
    @Select(" select top(1) VBELN,POSNR,MATNR,MAKTX,WERKS,LGORT,LGOBE,\n" +
            "(select sum(CAST(LFIMG AS FLOAT)) from  tb_SD_i where vbeln = #{VBELN})as LFIMG\n" +
            ",VRKME,ZJS,BEZEI from tb_SD_i where vbeln =  #{VBELN} ")
    public TbSdI selectSdi(String VBELN);
}
